/**
 * 
 */
package com.disys.examples;

/**
 * @author Ubaid Raja
 *
 */
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.HashMap;

public class Main {
	public static void main(String[] args) throws Exception {
		Connection conn = getMySqlConnection();
		System.out.println("Got Connection.");
		Statement st = conn.createStatement();
		//st.executeUpdate("drop table survey;");
		//st.executeUpdate("create table survey (id int,name varchar(30));");
		//st.executeUpdate("insert into survey (id,name ) values (1,'nameValue')");
		HashMap<String, Integer> sizeOfColumns = new HashMap<String, Integer>();
		ResultSet rsColumns = null;
		DatabaseMetaData meta = conn.getMetaData();
		rsColumns = meta.getColumns(null, null, "tx_140ERWOTCLOC", null);
		while (rsColumns.next()) {
			String columnName = rsColumns.getString("COLUMN_NAME");
			System.out.println("column name=" + columnName);
			//String columnType = rsColumns.getString("TYPE_NAME");
			//System.out.println("type:" + columnType);
			int size = rsColumns.getInt("COLUMN_SIZE");
			System.out.println("size:" + size);
			sizeOfColumns.put(columnName, size);
			//int nullable = rsColumns.getInt("NULLABLE");
//			if (nullable == DatabaseMetaData.columnNullable) {
//				System.out.println("nullable true");
//			} else {
//				System.out.println("nullable false");
//			}
//			int position = rsColumns.getInt("ORDINAL_POSITION");
//			System.out.println("position:" + position);

		}

		st.close();
		conn.close();
	}

	public static Connection getMySqlConnection() throws Exception {
		String driver = "org.gjt.mm.mysql.Driver";
		String url = "jdbc:mysql://localhost:3306/jsfcruddb";
		String username = "root";
		String password = "admin";

		Class.forName(driver);
		Connection conn = DriverManager.getConnection(url, username, password);
		return conn;
	}

	
}